package com.micromall.model;

import java.util.Date;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.activerecord.Model;
import com.baomidou.mybatisplus.annotations.TableName;
import java.io.Serializable;

/**
 * <p>
 * 会员表
 * </p>
 *
 * @author Dante Fung
 * @since 2017-07-26
 */
@TableName("MI_MEMBER")
public class MiMember extends Model<MiMember> {

    private static final long serialVersionUID = 1L;

    /**
     * 会员编号 国别(2位字母)+编号（7位数字）
     */
    @TableId("MEMBER_NO")
	private String memberNo;
    /**
     * 现住邮编
     */
	@TableField("PRESENT_ZIP_CODE")
	private String presentZipCode;
	@TableField("INSTITUITION_NUMBER")
	private String instituitionNumber;
    /**
     * IBAN
     */
	@TableField("IBAN_NO")
	private String ibanNo;
    /**
     * 直销商证发证日期(现在去掉)
     */
	@TableField("CD_DATE")
	private Date cdDate;
    /**
     * 身份证编号
     */
	@TableField("ID_NO")
	private String idNo;
    /**
     * 现住址城市
     */
	@TableField("ADDR")
	private String addr;
    /**
     * 备注
     */
	@TableField("REMARK")
	private String remark;
    /**
     * 欧盟税号
     */
	@TableField("EU_TAX_NO")
	private String euTaxNo;
    /**
     * 其它职业
     */
	@TableField("OTHER_JOB")
	private String otherJob;
    /**
     * 分行代码
     */
	@TableField("B_CODE")
	private String bCode;
    /**
     * 姓
     */
	@TableField("FIRST_NAME")
	private String firstName;
    /**
     * 收货国家编码
     */
	@TableField("SHIP_COUNTRY_CODE")
	private String shipCountryCode;
    /**
     * 波兰专用税种
     */
	@TableField("PESEL")
	private String pesel;
    /**
     * 接点人
     */
	@TableField("MI_LINK_NO")
	private String miLinkNo;
    /**
     * 税号
     */
	@TableField("TAX_NO")
	private String taxNo;
    /**
     * 审核日期
     */
	@TableField("MI_AUDIT_DATE")
	private Date miAuditDate;
    /**
     * 安全问题答案
     */
	@TableField("SECURITY_QUESTION_ANSWER")
	private String securityQuestionAnswer;
    /**
     * 用户名/姓名
     */
	@TableField("MI_USER_NAME")
	private String miUserName;
    /**
     * 银行更改时间，未更改过则为空白
     */
	@TableField("BANK_A_TIME")
	private Date bankATime;
    /**
     * 审核人账号，审核通过该会员的操作员帐号
     */
	@TableField("CHECK_NO")
	private String checkNo;
    /**
     * 如：510000
     */
	@TableField("ADDR_ZIP")
	private String addrZip;
    /**
     * 公司名称
     */
	@TableField("COMPANY_NAME")
	private String companyName;
    /**
     * 中国发展法改委
     */
	@TableField("LAW_MEMBER")
	private String lawMember;
	@TableField("TRANSIT_NUMBER")
	private String transitNumber;
    /**
     * 收货地址街道
     */
	@TableField("SHIPPING_ADDRESS1")
	private String shippingAddress1;
    /**
     * 身份证街道
     */
	@TableField("ID_ADDR1")
	private String idAddr1;
    /**
     * 收货地址城市
     */
	@TableField("SHIPPING_ADDRESS")
	private String shippingAddress;
    /**
     * 会员退出时间(不为空则参与奖金计算)
     */
	@TableField("EXIT_DATE")
	private Date exitDate;
    /**
     * 代理商编号
     */
	@TableField("AGENT_NO")
	private String agentNo;
    /**
     * 汇入银行代码
     */
	@TableField("PB_NO")
	private String pbNo;
    /**
     * 证件类型
     */
	@TableField("CERTIFICATE_TYPE")
	private String certificateType;
    /**
     * Y:有效;N:无效
     */
	@TableField("DATA_STATUS")
	private String dataStatus;
    /**
     * E通卡号
     */
	@TableField("ECARD_NO")
	private String ecardNo;
    /**
     * 联络电话
     */
	@TableField("PHONE")
	private String phone;
    /**
     * 银行户名
     */
	@TableField("B_NAME")
	private String bName;
    /**
     * 建档时间，建立该会员的时间
     */
	@TableField("CREATE_TIME")
	private Date createTime;
    /**
     * 现住国家
     */
	@TableField("PRESENT_COUNTRY_CODE")
	private String presentCountryCode;
    /**
     * 推荐人
     */
	@TableField("MI_RECOMMEND_NO")
	private String miRecommendNo;
    /**
     * 昵称(系统显示的名字都用昵称)
     */
	@TableField("PET_NAME")
	private String petName;
    /**
     * 重销商品编号(对PM_PRODUCT表主键) 空值则由公司默认指定
     */
	@TableField("PRODUCT_NO")
	private String productNo;
    /**
     * 备注
     */
	@TableField("MEMO")
	private String memo;
    /**
     * 汇入银行代码2
     */
	@TableField("PB_NO2")
	private String pbNo2;
    /**
     * 如：510000
     */
	@TableField("ID_ZIP")
	private String idZip;
    /**
     * 建档帐号，建立该会员的代理商帐号（区代）
     */
	@TableField("CREATE_NO")
	private String createNo;
    /**
     * 0不锁  1锁定
     */
	@TableField("COUNTING")
	private String counting;
    /**
     * 名
     */
	@TableField("LAST_NAME")
	private String lastName;
    /**
     * 开户银行
     */
	@TableField("OPEN_BANK")
	private String openBank;
    /**
     * 身份证城市
     */
	@TableField("ID_ADDR")
	private String idAddr;
	@TableField("SHIPPING_APT")
	private String shippingApt;
    /**
     * 银行账号
     */
	@TableField("B_NUM")
	private String bNum;
    /**
     * 直销商证号(现在去掉)
     */
	@TableField("CD_NO")
	private String cdNo;
    /**
     * 公司编码
     */
	@TableField("COMPANY_CODE")
	private String companyCode;
    /**
     * 申请类型
     */
	@TableField("APP_TYPE")
	private String appType;
    /**
     * 银行更改者，未更改过则为空白
     */
	@TableField("BANK_A_NO")
	private String bankANo;
    /**
     * 是否授权（0正常，1待审会员，2已提交待审会员）
     */
	@TableField("LOCKED")
	private String locked;
    /**
     * 如：广东广州
     */
	@TableField("ADDR_AREA")
	private String addrArea;
    /**
     * 教育日期
     */
	@TableField("EDUCATION_DATE")
	private Date educationDate;
    /**
     * 角色
     */
	@TableField("ROLE_ID")
	private String roleId;
    /**
     * SWIFT
     */
	@TableField("SWIFT_NO")
	private String swiftNo;
    /**
     * 直销商所属分支机构(现在去掉)
     */
	@TableField("CD_ORG")
	private String cdOrg;
    /**
     * 汇入银行代码1
     */
	@TableField("PB_NO1")
	private String pbNo1;
    /**
     * 等级 0.待审会员 1.银卡 2.金卡 3.白金卡 4.钻石卡 5铜级
     */
	@TableField("CARD_TYPE")
	private String cardType;
    /**
     * 审核时间，审核通过该会员的时间
     */
	@TableField("CHECK_TIME")
	private Date checkTime;
    /**
     * 0无教育 1有教育
     */
	@TableField("EDUCATION")
	private String education;
    /**
     * 手机号码
     */
	@TableField("MOBILE_PHONE")
	private String mobilePhone;
    /**
     * 出生/成立日期
     */
	@TableField("BIRTHDAY")
	private String birthday;
    /**
     * 现住址街道
     */
	@TableField("ADDR1")
	private String addr1;
    /**
     * 国别编码（身份证国家编码）
     */
	@TableField("COUNTRY_CODE")
	private String countryCode;
    /**
     * 开户银行所在城市
     */
	@TableField("B_CITY")
	private String bCity;
    /**
     * 门牌号码
     */
	@TableField("B_APT")
	private String bApt;
	@TableField("SSN_FEIN")
	private String ssnFein;
    /**
     * 汇款路线号码
     */
	@TableField("REMIT_NO")
	private String remitNo;
    /**
     * 备注(公司内部使用)
     */
	@TableField("REMARK_MANAGE")
	private String remarkManage;
    /**
     * 安全问题
     */
	@TableField("SECURITY_QUESTION")
	private String securityQuestion;
    /**
     * 电子邮箱
     */
	@TableField("EMAIL")
	private String email;
    /**
     * 默认：无，M 男性、F 女性
     */
	@TableField("SEX")
	private String sex;
    /**
     * 直销商所属地区(现在去掉)
     */
	@TableField("CD_AREA")
	private String cdArea;
    /**
     * 如：广东广州
     */
	@TableField("ID_AREA")
	private String idArea;


	public String getMemberNo() {
		return memberNo;
	}

	public void setMemberNo(String memberNo) {
		this.memberNo = memberNo;
	}

	public String getPresentZipCode() {
		return presentZipCode;
	}

	public void setPresentZipCode(String presentZipCode) {
		this.presentZipCode = presentZipCode;
	}

	public String getInstituitionNumber() {
		return instituitionNumber;
	}

	public void setInstituitionNumber(String instituitionNumber) {
		this.instituitionNumber = instituitionNumber;
	}

	public String getIbanNo() {
		return ibanNo;
	}

	public void setIbanNo(String ibanNo) {
		this.ibanNo = ibanNo;
	}

	public Date getCdDate() {
		return cdDate;
	}

	public void setCdDate(Date cdDate) {
		this.cdDate = cdDate;
	}

	public String getIdNo() {
		return idNo;
	}

	public void setIdNo(String idNo) {
		this.idNo = idNo;
	}

	public String getAddr() {
		return addr;
	}

	public void setAddr(String addr) {
		this.addr = addr;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public String getEuTaxNo() {
		return euTaxNo;
	}

	public void setEuTaxNo(String euTaxNo) {
		this.euTaxNo = euTaxNo;
	}

	public String getOtherJob() {
		return otherJob;
	}

	public void setOtherJob(String otherJob) {
		this.otherJob = otherJob;
	}

	public String getBCode() {
		return bCode;
	}

	public void setBCode(String bCode) {
		this.bCode = bCode;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getShipCountryCode() {
		return shipCountryCode;
	}

	public void setShipCountryCode(String shipCountryCode) {
		this.shipCountryCode = shipCountryCode;
	}

	public String getPesel() {
		return pesel;
	}

	public void setPesel(String pesel) {
		this.pesel = pesel;
	}

	public String getMiLinkNo() {
		return miLinkNo;
	}

	public void setMiLinkNo(String miLinkNo) {
		this.miLinkNo = miLinkNo;
	}

	public String getTaxNo() {
		return taxNo;
	}

	public void setTaxNo(String taxNo) {
		this.taxNo = taxNo;
	}

	public Date getMiAuditDate() {
		return miAuditDate;
	}

	public void setMiAuditDate(Date miAuditDate) {
		this.miAuditDate = miAuditDate;
	}

	public String getSecurityQuestionAnswer() {
		return securityQuestionAnswer;
	}

	public void setSecurityQuestionAnswer(String securityQuestionAnswer) {
		this.securityQuestionAnswer = securityQuestionAnswer;
	}

	public String getMiUserName() {
		return miUserName;
	}

	public void setMiUserName(String miUserName) {
		this.miUserName = miUserName;
	}

	public Date getBankATime() {
		return bankATime;
	}

	public void setBankATime(Date bankATime) {
		this.bankATime = bankATime;
	}

	public String getCheckNo() {
		return checkNo;
	}

	public void setCheckNo(String checkNo) {
		this.checkNo = checkNo;
	}

	public String getAddrZip() {
		return addrZip;
	}

	public void setAddrZip(String addrZip) {
		this.addrZip = addrZip;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getLawMember() {
		return lawMember;
	}

	public void setLawMember(String lawMember) {
		this.lawMember = lawMember;
	}

	public String getTransitNumber() {
		return transitNumber;
	}

	public void setTransitNumber(String transitNumber) {
		this.transitNumber = transitNumber;
	}

	public String getShippingAddress1() {
		return shippingAddress1;
	}

	public void setShippingAddress1(String shippingAddress1) {
		this.shippingAddress1 = shippingAddress1;
	}

	public String getIdAddr1() {
		return idAddr1;
	}

	public void setIdAddr1(String idAddr1) {
		this.idAddr1 = idAddr1;
	}

	public String getShippingAddress() {
		return shippingAddress;
	}

	public void setShippingAddress(String shippingAddress) {
		this.shippingAddress = shippingAddress;
	}

	public Date getExitDate() {
		return exitDate;
	}

	public void setExitDate(Date exitDate) {
		this.exitDate = exitDate;
	}

	public String getAgentNo() {
		return agentNo;
	}

	public void setAgentNo(String agentNo) {
		this.agentNo = agentNo;
	}

	public String getPbNo() {
		return pbNo;
	}

	public void setPbNo(String pbNo) {
		this.pbNo = pbNo;
	}

	public String getCertificateType() {
		return certificateType;
	}

	public void setCertificateType(String certificateType) {
		this.certificateType = certificateType;
	}

	public String getDataStatus() {
		return dataStatus;
	}

	public void setDataStatus(String dataStatus) {
		this.dataStatus = dataStatus;
	}

	public String getEcardNo() {
		return ecardNo;
	}

	public void setEcardNo(String ecardNo) {
		this.ecardNo = ecardNo;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getBName() {
		return bName;
	}

	public void setBName(String bName) {
		this.bName = bName;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public String getPresentCountryCode() {
		return presentCountryCode;
	}

	public void setPresentCountryCode(String presentCountryCode) {
		this.presentCountryCode = presentCountryCode;
	}

	public String getMiRecommendNo() {
		return miRecommendNo;
	}

	public void setMiRecommendNo(String miRecommendNo) {
		this.miRecommendNo = miRecommendNo;
	}

	public String getPetName() {
		return petName;
	}

	public void setPetName(String petName) {
		this.petName = petName;
	}

	public String getProductNo() {
		return productNo;
	}

	public void setProductNo(String productNo) {
		this.productNo = productNo;
	}

	public String getMemo() {
		return memo;
	}

	public void setMemo(String memo) {
		this.memo = memo;
	}

	public String getPbNo2() {
		return pbNo2;
	}

	public void setPbNo2(String pbNo2) {
		this.pbNo2 = pbNo2;
	}

	public String getIdZip() {
		return idZip;
	}

	public void setIdZip(String idZip) {
		this.idZip = idZip;
	}

	public String getCreateNo() {
		return createNo;
	}

	public void setCreateNo(String createNo) {
		this.createNo = createNo;
	}

	public String getCounting() {
		return counting;
	}

	public void setCounting(String counting) {
		this.counting = counting;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String getOpenBank() {
		return openBank;
	}

	public void setOpenBank(String openBank) {
		this.openBank = openBank;
	}

	public String getIdAddr() {
		return idAddr;
	}

	public void setIdAddr(String idAddr) {
		this.idAddr = idAddr;
	}

	public String getShippingApt() {
		return shippingApt;
	}

	public void setShippingApt(String shippingApt) {
		this.shippingApt = shippingApt;
	}

	public String getBNum() {
		return bNum;
	}

	public void setBNum(String bNum) {
		this.bNum = bNum;
	}

	public String getCdNo() {
		return cdNo;
	}

	public void setCdNo(String cdNo) {
		this.cdNo = cdNo;
	}

	public String getCompanyCode() {
		return companyCode;
	}

	public void setCompanyCode(String companyCode) {
		this.companyCode = companyCode;
	}

	public String getAppType() {
		return appType;
	}

	public void setAppType(String appType) {
		this.appType = appType;
	}

	public String getBankANo() {
		return bankANo;
	}

	public void setBankANo(String bankANo) {
		this.bankANo = bankANo;
	}

	public String getLocked() {
		return locked;
	}

	public void setLocked(String locked) {
		this.locked = locked;
	}

	public String getAddrArea() {
		return addrArea;
	}

	public void setAddrArea(String addrArea) {
		this.addrArea = addrArea;
	}

	public Date getEducationDate() {
		return educationDate;
	}

	public void setEducationDate(Date educationDate) {
		this.educationDate = educationDate;
	}

	public String getRoleId() {
		return roleId;
	}

	public void setRoleId(String roleId) {
		this.roleId = roleId;
	}

	public String getSwiftNo() {
		return swiftNo;
	}

	public void setSwiftNo(String swiftNo) {
		this.swiftNo = swiftNo;
	}

	public String getCdOrg() {
		return cdOrg;
	}

	public void setCdOrg(String cdOrg) {
		this.cdOrg = cdOrg;
	}

	public String getPbNo1() {
		return pbNo1;
	}

	public void setPbNo1(String pbNo1) {
		this.pbNo1 = pbNo1;
	}

	public String getCardType() {
		return cardType;
	}

	public void setCardType(String cardType) {
		this.cardType = cardType;
	}

	public Date getCheckTime() {
		return checkTime;
	}

	public void setCheckTime(Date checkTime) {
		this.checkTime = checkTime;
	}

	public String getEducation() {
		return education;
	}

	public void setEducation(String education) {
		this.education = education;
	}

	public String getMobilePhone() {
		return mobilePhone;
	}

	public void setMobilePhone(String mobilePhone) {
		this.mobilePhone = mobilePhone;
	}

	public String getBirthday() {
		return birthday;
	}

	public void setBirthday(String birthday) {
		this.birthday = birthday;
	}

	public String getAddr1() {
		return addr1;
	}

	public void setAddr1(String addr1) {
		this.addr1 = addr1;
	}

	public String getCountryCode() {
		return countryCode;
	}

	public void setCountryCode(String countryCode) {
		this.countryCode = countryCode;
	}

	public String getBCity() {
		return bCity;
	}

	public void setBCity(String bCity) {
		this.bCity = bCity;
	}

	public String getBApt() {
		return bApt;
	}

	public void setBApt(String bApt) {
		this.bApt = bApt;
	}

	public String getSsnFein() {
		return ssnFein;
	}

	public void setSsnFein(String ssnFein) {
		this.ssnFein = ssnFein;
	}

	public String getRemitNo() {
		return remitNo;
	}

	public void setRemitNo(String remitNo) {
		this.remitNo = remitNo;
	}

	public String getRemarkManage() {
		return remarkManage;
	}

	public void setRemarkManage(String remarkManage) {
		this.remarkManage = remarkManage;
	}

	public String getSecurityQuestion() {
		return securityQuestion;
	}

	public void setSecurityQuestion(String securityQuestion) {
		this.securityQuestion = securityQuestion;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public String getCdArea() {
		return cdArea;
	}

	public void setCdArea(String cdArea) {
		this.cdArea = cdArea;
	}

	public String getIdArea() {
		return idArea;
	}

	public void setIdArea(String idArea) {
		this.idArea = idArea;
	}

	@Override
	protected Serializable pkVal() {
		return this.memberNo;
	}

	@Override
	public String toString() {
		return "MiMember{" +
				"memberNo='" + memberNo + '\'' +
				", presentZipCode='" + presentZipCode + '\'' +
				", instituitionNumber='" + instituitionNumber + '\'' +
				", ibanNo='" + ibanNo + '\'' +
				", cdDate=" + cdDate +
				", idNo='" + idNo + '\'' +
				", addr='" + addr + '\'' +
				", remark='" + remark + '\'' +
				", euTaxNo='" + euTaxNo + '\'' +
				", otherJob='" + otherJob + '\'' +
				", bCode='" + bCode + '\'' +
				", firstName='" + firstName + '\'' +
				", shipCountryCode='" + shipCountryCode + '\'' +
				", pesel='" + pesel + '\'' +
				", miLinkNo='" + miLinkNo + '\'' +
				", taxNo='" + taxNo + '\'' +
				", miAuditDate=" + miAuditDate +
				", securityQuestionAnswer='" + securityQuestionAnswer + '\'' +
				", miUserName='" + miUserName + '\'' +
				", bankATime=" + bankATime +
				", checkNo='" + checkNo + '\'' +
				", addrZip='" + addrZip + '\'' +
				", companyName='" + companyName + '\'' +
				", lawMember='" + lawMember + '\'' +
				", transitNumber='" + transitNumber + '\'' +
				", shippingAddress1='" + shippingAddress1 + '\'' +
				", idAddr1='" + idAddr1 + '\'' +
				", shippingAddress='" + shippingAddress + '\'' +
				", exitDate=" + exitDate +
				", agentNo='" + agentNo + '\'' +
				", pbNo='" + pbNo + '\'' +
				", certificateType='" + certificateType + '\'' +
				", dataStatus='" + dataStatus + '\'' +
				", ecardNo='" + ecardNo + '\'' +
				", phone='" + phone + '\'' +
				", bName='" + bName + '\'' +
				", createTime=" + createTime +
				", presentCountryCode='" + presentCountryCode + '\'' +
				", miRecommendNo='" + miRecommendNo + '\'' +
				", petName='" + petName + '\'' +
				", productNo='" + productNo + '\'' +
				", memo='" + memo + '\'' +
				", pbNo2='" + pbNo2 + '\'' +
				", idZip='" + idZip + '\'' +
				", createNo='" + createNo + '\'' +
				", counting='" + counting + '\'' +
				", lastName='" + lastName + '\'' +
				", openBank='" + openBank + '\'' +
				", idAddr='" + idAddr + '\'' +
				", shippingApt='" + shippingApt + '\'' +
				", bNum='" + bNum + '\'' +
				", cdNo='" + cdNo + '\'' +
				", companyCode='" + companyCode + '\'' +
				", appType='" + appType + '\'' +
				", bankANo='" + bankANo + '\'' +
				", locked='" + locked + '\'' +
				", addrArea='" + addrArea + '\'' +
				", educationDate=" + educationDate +
				", roleId='" + roleId + '\'' +
				", swiftNo='" + swiftNo + '\'' +
				", cdOrg='" + cdOrg + '\'' +
				", pbNo1='" + pbNo1 + '\'' +
				", cardType='" + cardType + '\'' +
				", checkTime=" + checkTime +
				", education='" + education + '\'' +
				", mobilePhone='" + mobilePhone + '\'' +
				", birthday='" + birthday + '\'' +
				", addr1='" + addr1 + '\'' +
				", countryCode='" + countryCode + '\'' +
				", bCity='" + bCity + '\'' +
				", bApt='" + bApt + '\'' +
				", ssnFein='" + ssnFein + '\'' +
				", remitNo='" + remitNo + '\'' +
				", remarkManage='" + remarkManage + '\'' +
				", securityQuestion='" + securityQuestion + '\'' +
				", email='" + email + '\'' +
				", sex='" + sex + '\'' +
				", cdArea='" + cdArea + '\'' +
				", idArea='" + idArea + '\'' +
				'}';
	}
}
